/*
 Navicat Premium Data Transfer

 Source Server         : 本地_mysql
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : renren_cloud_tenant

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 11/01/2022 17:54:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for work_assembly_vote
-- ----------------------------
DROP TABLE IF EXISTS `work_assembly_vote`;
CREATE TABLE `work_assembly_vote` (
  `id` int unsigned NOT NULL COMMENT 'ID',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '主题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '内容',
  `imgurl` varchar(2550) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '图片',
  `alternative` varchar(2550) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备选项',
  `allow_voters_id` int DEFAULT NULL COMMENT '投票ID',
  `allow_voters_range` int DEFAULT NULL COMMENT '投票人区域',
  `allow_voters_type` int DEFAULT NULL COMMENT '投票人类型',
  `result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '结果',
  `start_time` datetime(6) DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime(6) DEFAULT NULL COMMENT '结束时间',
  `anonymous` bit(1) DEFAULT NULL COMMENT '匿名',
  `checks` bit(1) DEFAULT NULL COMMENT '多选',
  `remark` varchar(255) DEFAULT NULL COMMENT '说明',
  `creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `logical_delete` bit(1) DEFAULT b'1' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='信息投票';

-- ----------------------------
-- Records of work_assembly_vote
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
